package cn.jyc.ssm03.dao;

import cn.jyc.ssm03.pojo.CustCount01;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;

public interface CustCount01Mapper {
    @Select("select address name,count(*) value from bus_customers group by 1")
    public List<CustCount01> qry01();
    @Select("select sex name,count(*) value from bus_customers group by 1")
    public List<CustCount01> qry02();
    @Select("select cartype name,count(*) value from bus_cars group by 1 order by 2 desc")
    public List<CustCount01> qry03();
    @Select("select dt name,sum(xse) value from sys_dt_sell where dt>=#{p1} and dt<=#{p2} group by 1 order by 1")
    public List<CustCount01> qry04(@Param("p1") String bgdt,@Param("p2") String fndt);
}
